var createError = require('http-errors');
var express = require('express');
var path = require('path');
var cookieParser = require('cookie-parser');
var logger = require('morgan');

var indexRouter = require('./routes/index');
var loginRouter = require('./routes/login');
var noteRouter = require('./routes/note');

var cors = require('./middleware/cors');
var charset = require('./middleware/charset');

var app = express();

// 连接池连接mysql
var mysql = require('mysql');
var myConnection = require('express-myconnection');
var dbOptions = {
  host: 'localhost', // localhost
  user: 'root',
  password: 'root',
  port: 3306,
  database: 'filters'
};
app.use(myConnection(mysql, dbOptions, 'single'));

// view engine setup
app.set('views', path.join(__dirname, 'views'));
app.set('view engine', 'pug');

app.use(logger('dev'));
app.use(express.json());
app.use(express.urlencoded({
  extended: false
}));
app.use(cookieParser());
app.use(express.static(path.join(__dirname, 'public')));

app.use(cors()); // 处理跨域
app.use(charset()); // 处理字符编码

app.use('/', indexRouter);
app.use('/login', loginRouter);
app.use('/note', noteRouter);

// catch 404 and forward to error handler
app.use(function (req, res, next) {
  next(createError(404));
});

// error handler
app.use(function (err, req, res, next) {
  console.log(err);
  // set locals, only providing error in development
  res.locals.message = err.message;
  res.locals.error = req.app.get('env') === 'development' ? err : {};

  // render the error page
  res.status(err.status || 500);
  res.render('error');
});

module.exports = app;